
USE [meps]
GO
create USER InputPayment for LOGIN  InputPayment;
CREATE ROLE [InputPaymentRole] AUTHORIZATION [dbo]
EXEC dbo.sp_addrolemember @rolename=N'InputPaymentRole', @membername=N'InputPayment'
EXEC dbo.sp_addrolemember @rolename=N'Browser', @membername=N'InputPayment'
GRANT INSERT ON [dbo].[AutomatLog] TO [InputPaymentRole] 

USE [sms_p]
GO
create USER InputPayment for LOGIN  InputPayment;
CREATE ROLE [InputPaymentRole] AUTHORIZATION [dbo]
EXEC dbo.sp_addrolemember @rolename=N'InputPaymentRole', @membername=N'InputPayment'
EXEC dbo.sp_addrolemember @rolename=N'Executer', @membername=N'InputPayment'
GRANT execute ON SCHEMA :: InputPayment TO InputPaymentRole;
GO
USE [sms]
GO
create USER InputPayment for LOGIN  InputPayment;
CREATE ROLE [InputPaymentRole] AUTHORIZATION [dbo]
EXEC dbo.sp_addrolemember @rolename=N'InputPaymentRole', @membername=N'InputPayment'
EXEC dbo.sp_addrolemember @rolename=N'Browser', @membername=N'InputPayment'
GRANT UPDATE ON Monitor TO InputPaymentRole
grant insert on AutomatLog to InputPaymentRole
GO



